<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>
        openGauss自动化长稳-CI连跑分析报告
    </title>
    <style type="text/css">
            LogTitle {
                display: block;
                background-color: #b6d7a8;
                padding: 10px; }

            textTitle {
                display: block;
                font-size: 16px;
                padding: 5px;
                font-weight: bold;
                background-color:AntiqueWhite;
                font-family:arial;
                font-weight:bold;}

            .table {
                table-layout:fixed;
                word-break:break-all;}

            .modal.fade.in {
                top: 20%;
            }

    </style>
</head>
<body>
{% extends 'base.html' %}
{% block body_part %}
<LogTitle><em style="font-size: 20px;"><b>一、负载测试</b></em><br></LogTitle>
<div class="container-fluid">
    <br>
    <p><textTitle><b>执行参数</b></textTitle></p>
    <div class="row">
        <div class="col-md-6" style="float: left;">
            <table class="table table-bordered">
                <thead>
                <tr>
                    <th>测试信息</th>
                    <th>说明</th>
                </tr>
                </thead>
                <tbody>
                <tr>
                    <td>测试模型</td>
                    <td>TPC-C、Sysbench</td>
                </tr>
                <tr>
                    <td>数据量</td>
                    <td>Warehouse=1500, Sysbench table-size=50w</td>
                </tr>
                <tr>
                    <td>测试接口</td>
                    <td>JDBC</td>
                </tr>
                <tr>
                    <td>TPCC并发数</td>
                    <td>1200</td>
                </tr>
                <tr>
                    <td>Sysbench并发数</td>
                    <td>30</td>
                </tr>
                <tr>
                    <td>执行时间</td>
                    <td>7*24h</td>
                </tr>
                </tbody>
            </table>
        </div>
    </div>
    <br>

</div>

<div class="container-fluid">
    <p><textTitle><b>执行结果</b></textTitle></p>
    <div class="row">
        <div class="col-md-6" style="float: left;">
            <table class="table table-bordered">
                <thead>
                <tr>
                    <th>执行环境</th>
                    <th>开始时间</th>
                    <th>状态</th>
                    <th>详情</th>
                </tr>
                </thead>
                <tbody>
                {% for data in data_dict.data_list %}
                <tr>
                    <td>{{ data.run_os }}</td>
                    <td>{{ data.start_time }}</td>
                    {% if data.status == "running" %}
                    <td style="color:orange">执行中</td>
                    {% elif data.status == "error" %}
                    <td style="color:grey">暂无环境</td>
                    {% else %}
                    <td style="color:green">已完成</td>
                    {% endif %}
                    {% if data.run_os == "x86_openEuler" %}
                    <td style="color:grey"> 暂无法查看</td>
                    {% else %}
                    <td><a
                            href="http://90.90.44.165:3000/d/9CWBz0bik2/chang-wen-jian-kong-0?orgId=1&from=now-7d&to=now&var-origin_prometheus=&var-job=pushgateway-177&var-hostname=All&var-node=node_exporter&var-device=All&var-interval=2m&var-maxmount=%2Fpg_xlog&var-show_hostname=openGauss177&var-total=1"
                            target="_blank">查看图表</a></td>
                    {% endif %}
                </tr>
                {% endfor %}
                </tbody>
            </table>
        </div>
    </div>
    <br>
</div>

<LogTitle><em style="font-size: 20px;"><b>二、SQLSmith测试</b></em><br></LogTitle>
<div class="container-fluid">
    <br>
    <p><textTitle><b>执行参数</b></textTitle></p>
    <div class="row">
        <div class="col-md-6" style="float: left;">
            <table class="table table-bordered">
                <thead>
                <tr>
                    <th>测试信息</th>
                    <th>说明</th>
                </tr>
                </thead>
                <tbody>
                <tr>
                    <td>sqlsmith客户端</td>
                    <td>Ubuntu 20.04.3 LTS x86_64</td>
                </tr>
                <tr>
                    <td>sqlsmith服务端</td>
                    <td>openEuler release 20.03 (LTS) x86_64</td>
                </tr>
                <tr>
                    <td>数据库形态</td>
                    <td>单机</td>
                </tr>
                <tr>
                    <td>执行时间</td>
                    <td>7*24h</td>
                </tr>
                </tbody>
            </table>
        </div>
    </div>
    <br>
</div>

<div class="container-fluid">
    <p><textTitle><b>执行结果</b></textTitle></p>
    <div class="row">
        <div class="col-md-6" style="float: left;">
            <table id="sqlsmith_table" class="table table-bordered">
                <thead>
                <tr>
                    <th>测试模型</th>
                    <th>开始时间</th>
                    <th>状态</th>
                    <th>详情</th>
                </tr>
                </thead>
                <tbody>
                <tr>
                    <td>SQLSmith</td>
                    <td>{{ data_dict.sqlsmith_list.start_time }}</td>
                    {% if data_dict.sqlsmith_list.status == "true" %}
                    <td style="color:orange">执行中</td>
                    {% else %}
                    <td style="color:grey">未执行</td>
                    {% endif %}
                    <td><a
                            href="http://10.190.105.219:8080/job/sqlsmith_execute/label=sqlsmith_ubuntu_7.220.77.159/lastBuild/"
                            target="_blank">查看执行情况</a></td>
                </tr>
                </tbody>
            </table>
        </div>
    </div>
    <br>
</div>

<script type="text/javascript">
</script>
{% endblock %}
</body>
</html>